Creating Business Applications with Office 365 by Jeffrey M. Rhodes

Author:Jeffrey M. Rhodes
Language: eng
Format: epub
ISBN: 9781484253311
Publisher: Apress

4We also created a DaysPassed column as in past examples using the formula =DateTime.From(DateTime.LocalNow()) - [Created]. We can use this in future years to compare survey results over time.

© Jeffrey M. Rhodes 2019

J. M. RhodesCreating Business Applications with Office 365https://doi.org/10.1007/978-1-4842-5331-1_13

13. Power BI Case Study: Monitoring BMC Remedy Help Tickets

Jeffrey M. Rhodes1

(1)Colorado, CO, USA

Power BI can also be used for non-Office 365. An example that we have found helpful is in monitoring Remedy tickets. Remedy is an IT Service Management software that manages incidents, work orders, and other items. An important task is monitoring ticket status, how long they have been open, whether they have been assigned, and other tasks. Before Power BI, this had been accomplished by exporting data from Remedy to Excel and then creating charts. Not only was this labor-intensive, but the data was stale by the time it was presented at a staff meeting. Figure 83 shows one of our Power BI dashboards. It covers data from the previous 90 days and shows the number of tickets by support group (section), the status, the organization (Mission Element) with the issue, who submitted the ticket,1 who the ticket was assigned to, and so on.

Figure 83Power BI dashboard showing Remedy ticket data

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.